{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["March 13 Non Calculator"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"March 13 Non Calculator","index":0,"n_rows":40,"n_cols":35,"rows_kept":40,"cut":false,"hidden":false,"merged":[[6,30,7,30],[6,31,7,31],[0,0,0,26]]}
["March 13 Non Calculator"]
[null,"q1","q2","q3","q4","q5","q6","q7a","q7b","q8","q9a and b","q9c","q10","q11","q12","q13","q14","q15","q16","q17","q18","q19","q20ai, ii","q20b","q21","q22","q23","q24","q25","q26"]
[null,"Multiplication and Division","Scattergraphs","Questionnaires","Drawing Straight Line Graphs","Sequences","Conversion graphs","Collecting Like Terms","Solving Equations","Worded LCM Questions","Index Notation","Fractional & Negative Indices","Angles in Parallel Lines","Percentages","Ratio","Angles in Polygons","Cumulative Frequency","Loci and Construction","Standard Form","Algebraic Fractions","Mixed Transformations","Circle Theorems","Expand & Factorise Quadratics","Solving Quadratics by Factorisation","Proof","Enlargements by Negative SF","Spheres and Cones","Tree Diagrams","Transformations of Functions","Vectors"]
["Max Mark",3,4,3,4,3,5,2,2,3,3,1,4,5,4,3,7,4,4,3,3,3,3,1,4,3,3,5,3,5]
["Class Average (%)",{"$f":"AVERAGE(B9:B40)/B4","v":0.47619047619047622},0.38392857142857145,0.54761904761904756,0.4017857142857143,0.5357142857142857,0.27142857142857146,0.875,0.6964285714285714,0.61904761904761907,0.5357142857142857,1.7142857142857142,0.29464285714285715,0.25714285714285717,0.4017857142857143,0.5357142857142857,0.21428571428571427,0.38392857142857145,0.26785714285714285,0.54761904761904756,0.51190476190476197,0.40476190476190471,0.4285714285714286,1.3214285714285714,0.3482142857142857,0.55952380952380953,0.52380952380952384,{"$f":"AVERAGE(AB9:AB40)/AB4","v":0.25},0.6428571428571429,0.32142857142857145]
["Standard Deviation",{"$f":"IF(COUNT(B9:B36)<2,\"\",STDEV(B9:B40)/B4)","v":0.29297075555358998},0.2677248350482026,0.30380692529006548,0.24850744934700122,0.35531572599331152,0.21231901723436147,0.50230948111180906,0.49701489869400245,0.31050583600256532,0.30549542457877427,0.9371802805793974,0.20473075621333139,0.17935805576921315,0.21878542797010841,0.34353866225398405,0.11983864182969443,0.22029171376481491,0.24465178796505319,0.35386502872393577,0.36831439934736171,0.27751310141679059,0.40426881470673154,0.98332660745614775,0.24850744934700122,0.27297434161777528,0.27857029801244837,{"$f":"IF(COUNT(AB9:AB36)<2,\"\",STDEV(AB9:AB40)/AB4)","v":0.16887426837300737},0.31333295808450645,0.20612319735239043]
[null,"q1","q2","q3","q4","q5","q6","q7a","q7b","q8","q9a and b","q9c","q10","q11","q12","q13","q14","q15","q16","q17","q18","q19","q20ai, ii","q20b","q21","q22","q23","q24","q25","q26","Total Marks","Grade"]
["Name"]
["Sample student 1",{"$f":"ROUND(RAND()*$B$4,0)","v":1},3,2,1,0,1,1,2,3,1,2,2,3,1,3,2,{"$f":"ROUND(RAND()*$B$4,0)","v":2},0,2,1,0,0,1,1,2,2,2,3,3,{"$f":"IF(AD9=\"\",\"\",SUM(B9:AD9))","v":47},{"$f":"IF(AE9=\"\",\"\",VLOOKUP(AE9,$AH$13:$AI$34,2))","v":"C1"}]
["Sample student 2",1,0,1,1,1,2,3,3,3,3,2,2,2,1,1,1,1,1,2,2,2,3,2,2,1,1,2,2,2,{"$f":"IF(AD10=\"\",\"\",SUM(B10:AD10))","v":50},{"$f":"IF(AE10=\"\",\"\",VLOOKUP(AE10,$AH$13:$AI$34,2))","v":"B3"},null,"Grade Boundaries"]
["Sample student 3",1,0,2,2,1,3,2,2,0,1,2,1,0,2,3,2,0,1,1,0,2,1,2,1,2,1,2,1,2,40,"C2"]
["Sample student 4",2,1,2,3,1,2,3,2,1,1,2,2,1,3,2,2,3,3,1,3,2,1,2,1,3,2,2,1,1,55,"B2",null,"Non- Calc"]
["Sample student 5",3,3,3,0,3,3,3,1,1,1,1,2,0,2,0,1,3,1,0,3,2,3,2,2,1,1,1,3,1,50,"B3",null,0,"F3"]
["Sample student 6",1,2,1,1,1,0,0,1,2,1,1,0,3,1,1,1,1,1,1,3,1,0,3,0,1,1,1,2,2,34,"C3",null,{"$f":"AH13+(AH16-AH13)/3","v":2.3333333333333335},"F2"]
["Sample student 7",3,1,2,1,3,2,2,1,3,1,3,1,1,2,2,1,2,2,2,0,0,3,0,3,1,2,0,2,2,48,"B3",null,{"$f":"AH13+2*(AH16-AH13)/3","v":4.666666666666667},"F1"]
["Sample student 8",1,2,1,3,1,2,0,1,2,2,1,2,2,1,1,3,1,1,2,0,2,0,1,2,2,1,0,3,0,40,"C2",null,7,"E3"]
["Sample student 9",0,1,1,3,3,1,2,0,3,1,3,1,3,2,0,2,3,3,0,0,3,0,2,1,3,2,0,2,2,47,"C1",null,{"$f":"AH16+(AH19-AH16)/3","v":9.6666666666666661},"E2"]
["Sample student 10",1,2,2,1,2,1,2,1,1,3,0,0,1,3,2,1,1,1,2,3,1,3,2,1,2,0,1,1,0,41,"C2",null,{"$f":"AH16+2*(AH19-AH16)/3","v":12.333333333333332},"E1"]
["Sample student 11",2,3,2,1,0,0,2,1,2,3,2,1,1,0,2,0,2,2,2,1,1,0,0,3,2,1,2,2,2,42,"C2",null,15,"D3"]
["Sample student 12",2,3,1,0,2,0,1,2,1,2,2,1,0,2,0,3,2,0,3,2,1,1,0,1,2,2,2,1,1,40,"C2",null,{"$f":"AH19+(AH22-AH19)/3","v":20.333333333333332},"D2"]
["Sample student 13",3,1,0,2,0,1,2,0,3,2,3,1,1,0,3,1,1,1,3,1,1,2,1,3,0,3,0,2,2,43,"C1",null,{"$f":"AH19+2*(AH22-AH19)/3","v":25.666666666666664},"D1"]
["Sample student 14",1,1,1,2,3,1,3,3,1,2,3,2,1,1,2,1,2,2,1,3,1,1,0,0,1,2,0,2,2,45,"C1",null,31,"C3"]
["Sample student 15",1,1,2,2,2,0,0,2,1,1,1,0,2,3,0,1,1,1,0,2,2,1,0,2,1,1,0,2,3,35,"C3",null,{"$f":"AH22+(AH25-AH22)/3","v":36.666666666666664},"C2"]
["Sample student 16",2,1,1,2,2,1,3,3,3,1,2,0,1,2,3,{"$f":"ROUND(RAND()*$B$4,0)","v":3},1,2,0,1,2,0,3,1,0,1,2,3,2,48,"B3",null,{"$f":"AH22+2*(AH25-AH22)/3","v":42.333333333333336},"C1"]
["Sample student 17",{"$f":"ROUND(RAND()*$B$4,0)","v":0},3,0,2,0,1,2,0,1,1,2,3,2,1,2,2,2,0,1,1,1,1,0,1,1,2,1,1,0,34,"C3",null,48,"B3"]
["Sample student 18",2,2,2,1,2,2,1,3,3,2,0,1,2,2,3,2,0,1,3,2,2,0,2,2,2,1,0,2,1,48,"B3",null,{"$f":"AH25+(AH28-AH25)/3","v":54},"B2"]
["Sample student 19",2,0,2,3,3,3,3,1,1,3,3,1,2,2,2,1,2,0,0,2,2,3,1,1,3,2,2,3,3,56,"B2",null,{"$f":"AH25+2*(AH28-AH25)/3","v":60},"B1"]
["Sample student 20",1,1,1,0,3,0,0,1,2,2,2,2,0,1,2,2,1,3,3,0,1,0,0,0,2,1,1,1,2,35,"C3",null,66,"A3"]
["Sample student 21",1,2,3,1,1,0,2,1,1,3,3,0,1,2,0,0,1,0,3,0,2,0,1,1,2,2,2,3,3,41,"C2",null,{"$f":"AH28+(AH31-AH28)/3","v":71.666666666666671},"A2"]
["Sample student 22",1,3,2,0,1,3,1,3,3,1,1,1,1,3,1,1,1,1,3,2,0,1,1,3,2,0,2,3,0,45,"C1",null,{"$f":"AH28+2*(AH31-AH28)/3","v":77.333333333333329},"A1"]
["Sample student 23",2,0,3,2,3,1,2,1,1,0,1,2,0,1,1,2,2,0,3,3,1,3,1,1,2,1,1,0,1,41,"C2",null,83," A*3"]
["Sample student 24",1,0,3,3,0,2,2,1,2,1,2,0,1,0,1,2,0,0,2,3,1,0,1,1,1,2,2,3,1,38,"C2",null,{"$f":"AH31+(AH34-AH31)/3","v":88.666666666666671},"A*2"]
["Sample student 25",0,2,1,2,2,0,1,1,2,0,0,1,1,1,2,2,3,0,1,2,0,3,3,0,3,3,2,2,0,40,"C2",null,{"$f":"AH31+2*(AH34-AH31)/3","v":94.333333333333329},"A*1"]
["Sample student 26",3,1,0,1,1,3,3,2,1,1,1,2,1,2,1,2,1,0,2,1,0,2,2,0,2,1,2,3,1,42,"C2",null,100,"A*1"]
["Sample student 27",1,3,2,3,2,1,1,0,3,3,2,1,1,2,3,1,2,2,2,1,0,2,2,3,1,3,2,0,3,52,"B3"]
["Sample student 28",{"$f":"ROUND(RAND()*$B$4,0)","v":1},{"$f":"ROUND(RAND()*$B$4,0)","v":1},3,2,2,2,2,0,2,2,1,1,2,2,2,0,2,1,1,1,1,2,2,2,2,3,1,1,3,47,"C1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]